The Balances Screen displays the outstanding debtor balances by the age of the balance. Display modes are available which will display:
In addition, balances as they were aged in prior periods can also be viewed. Once a currency has been selected, the Credit Limit amounts, Month to Date, Year to Date and Last Payment Amount fields are also shown (in the Analysis Section ) with those values in the selected currency displayed.
Screen Shot 20: Agent Balances Screen – Base Currency
When a debtor has multiple currencies attached, initial entry to this screen is the "Base Currency" display. The Base Currency is the final accounting currency of the system. |
This screen is in 4 sections:
Agent Currencies Section
This section lists the currencies which are attached to the agent. Clicking on a currency name and will display the balances in that currency.
Prior Periods Section
This shows the current debtors accounting period at the bottom of the list, with all previously closed periods above it. To view the aging in prior periods, click the accounting period required.
Aged Balances Section
This section displays the balances by age.
The Base Currency balances as shown in Screen Shot 20 Agent Balances Screen – Base Currency are the total amount owed, for all currencies—i.e., the sum of all New Zealand Dollar and United States Dollar transactions. |
The Aging is broken down into seven periods:
Overdue 4+
The total value of all transactions in the selected currency whose age periods are 4 periods or older than the current accounting period.
Overdue 3
The total value of all transactions in the selected currency whose age periods are 3 periods older than the current accounting period.
Overdue 2
The total value of all transactions in the selected currency whose age periods are 2 periods older than the current accounting period.
Overdue 1
The total value of all transactions in the selected currency whose age periods are 1 period older than the current accounting period.
Current
The total value of all transactions in the selected currency whose age periods are the same as the current accounting period.
Total Due
The total in the selected currency of Overdue 4+ through to Current Period fields.
Future Aged
The total value of all transactions in the selected currency whose age periods are in advance of the current accounting period.
Future Entered
The total value of all transactions in the selected currency whose transaction date is in advance of the current period ending date.
Total
The Total Due value plus the Future Aged and Future Entered valuesin the selected currency.
Analysis Section
If the debtor has multiple currencies showing in the Supplier Currencies panel (), on entry to the balances screen, the 'Base Currency' values are displayed which are made up of the sum of transactions in all currencies attached to the debtor, expressed in base currency. The Analysis panel will not display until a currency other than Base Currency has been selected. |
Month-to-Date
Total revenue for the agent in the selected currency for the current period month.
Year-to-Date
Total revenue for the agent in the selected currency for the current financial year.
Total Credit Limit
The value of any credit limit set against this currency under the Debtors Application .
Credit Remaining
The credit limit value remaining. This is calculated as Credit Limit minus Total Balance Due.
If a debtor does not have a credit limit set, the Credit Remaining field will display a negative amount as in Screen Shot 21 Agent Balances Screen – USD Currency. |
Last Receipt Amount
The value of the last receipt posted in the selected currency.
Last Receipt Date
The date of the last receipt in the selected currency.
Screen Shot 21: Agent Balances Screen – USD Currency
Screen Shot 21 Agent Balances Screen – USD Currency is displaying balances in USD in the left hand column, and Base Currency (NZD) in the right hand column.
Note that there is only one accounting period (the current period) displayed in the Prior Periods panel. This is because the only USD transaction has been entered in this period.
Screen Shot 22: Agent Balances Screen – NZD Currency